1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10
11 namespace SoftQuanLyNhaHang.Controllers
12 {
13 class BomItemCtrl
14 {
15 // Method Add
16 public static int InsertBomItem(int _IdBomItem, int _IdBom, int _IdKho, string _ChuanMaVach, string _TrangThai, string _LoaiHangHoa, double _GiaBan, float _SoLuong, string _TenSanPham, int _DonViTinhId, string _TenDonViTinh)
17 {
18 try
19 {
20 Models.BomItemMod bomItem = new Models.BomItemMod(_IdBomItem, _IdBom, _IdKho, _ChuanMaVach, _TrangThai, _LoaiHangHoa, _GiaBan, _SoLuong, _TenSanPham, _DonViTinhId, _TenDonViTinh);
21 return bomItem.InsertBomItem();
22 }
23 catch
24 {
25 return 0;
26 }
27 }
28
29 //update
30 public static int UpdateBomItem(int _IdBomItem, int _IdBom, int _IdKho, string _ChuanMaVach, string _TrangThai, string _LoaiHangHoa, double _GiaBan, float _SoLuong, string _TenSanPham, int _DonViTinhId, string _TenDonViTinh)
31 {
32 try
33 {
34 Models.BomItemMod bomItem = new Models.BomItemMod(_IdBomItem, _IdBom, _IdKho, _ChuanMaVach, _TrangThai, _LoaiHangHoa, _GiaBan, _SoLuong, _TenSanPham, _DonViTinhId, _TenDonViTinh);
35 return bomItem.UpdateBomItem();
36 }
37 catch
38 {
39 return 0;
40 }
41 }
42
43 //delete
44 public static int DeleteBomItem(int _IdBomItem)
45 {
46 try
47 {
48 Models.BomItemMod bomItem = new Models.BomItemMod(_IdBomItem);
49 return bomItem.DeleteBomItem();
50 }
51 catch
52 {
53 return 0;
54 }
55 }
56
57 //search all
58 public static DataSet FillDataSet_getBomItem_SearchAll(int _IdBomItem, int _IdBom, int _IdKho, string _ChuanMaVach, string _TrangThai, string _LoaiHangHoa, double _GiaBan, float _SoLuong, string _TenSanPham, int _DonViTinhId, string _TenDonViTinh)
59 {
60 try
61 {
62 Models.BomItemMod sp = new Models.BomItemMod(_IdBomItem, _IdBom, _IdKho, _ChuanMaVach, _TrangThai, _LoaiHangHoa, _GiaBan, _SoLuong, _TenSanPham, _DonViTinhId, _TenDonViTinh);
63 return sp.FillDataSet_getBomItem_SearchAll();
64
65 }
66 catch
67 {
68 return null;
69 }
70 }
71
72 //get loai hang hoa va chuan ma vach
73 public static DataSet FillDataSet_getBomItem_ByLoaiHangHoa_ChuanMaVach(int _IdBom, string _LoaiHangHoa, string _ChuanMaVach)
74 {
75 try
76 {
77 Models.BomItemMod sp = new Models.BomItemMod(_IdBom, _LoaiHangHoa, _ChuanMaVach);
78 return sp.FillDataSet_getBomItem_ByLoaiHangHoa_ChuanMaVach();
79
80 }
81 catch
82 {
83 return null;
84 }
85 }
86
87 //lay san pham kuyen mai
88 public static DataSet FillDataSet_BomItem_Get_SpKhuyenMai(int _IdBomItem, int _IdBom, string _ChuanMaVach, string _TrangThai, int _SoLuong,DateTime _NgayBanHang)
89 {
90 try
91 {
92 Models.BomItemMod sp = new Models.BomItemMod(_IdBomItem, _IdBom, _ChuanMaVach, _TrangThai, _SoLuong, _NgayBanHang);
93 return sp.FillDataSet_BomItem_Get_SpKhuyenMai();
94
95 }
96 catch
97 {
98 return null;
99 }
100 }
101 //Dem so san pham khuyen mai
102 public static DataSet FillDataSet_BomItem_Get_SpKhuyenMai_Count(int _IdBomItem, int _IdBom, string _ChuanMaVach, string _TrangThai, float _SoLuong, DateTime _NgayBanHang)
103 {
104 try
105 {
106 Models.BomItemMod sp = new Models.BomItemMod(_IdBomItem, _IdBom, _ChuanMaVach, _TrangThai, _SoLuong, _NgayBanHang);
107 return sp.FillDataSet_BomItem_Get_SpKhuyenMai_Count();
108
109 }
110 catch
111 {
112 return null;
113 }
114 }
115
116 //kiem tra khuyen mai
117 public static DataSet FillDataSet_BomItem_Get_SpKhuyenMai_KiemTra(string _IdBomStr, string _LoaiHangHoa, int _KhachHangId, DateTime _NgayBanHang)
118 {
119 try
120 {
121 Models.BomItemMod sp = new Models.BomItemMod( _IdBomStr, _LoaiHangHoa, _KhachHangId, _NgayBanHang);
122 return sp.FillDataSet_BomItem_Get_SpKhuyenMai_KiemTra();
123
124 }
125 catch
126 {
127 return null;
128 }
129 }
130
131 //danh sach khuyen mai
132 public static DataSet FillDataSet_BomItem_Get_SpKhuyenMai2(string _IdBomStr, string _LoaiHangHoa, int _KhachHangId, DateTime _NgayBanHang)
133 {
134 try
135 {
136 Models.BomItemMod sp = new Models.BomItemMod(_IdBomStr, _LoaiHangHoa, _KhachHangId, _NgayBanHang);
137 return sp.FillDataSet_BomItem_Get_SpKhuyenMai2();
138
139 }
140 catch
141 {
142 return null;
143 }
144 }
145
146 //up date theo gia km
147 public static DataSet FillDataSet_BomItem_Get_ChuanMaVach_Khach_MuaHang(string _IdBomStr, string _LoaiHangHoa, int _KhachHangId, DateTime _NgayBanHang)
148 {
149 try
150 {
151 Models.BomItemMod sp = new Models.BomItemMod(_IdBomStr, _LoaiHangHoa, _KhachHangId, _NgayBanHang);
152 return sp.FillDataSet_BomItem_Get_ChuanMaVach_Khach_MuaHang();
153
154 }
155 catch
156 {
157 return null;
158 }
159 }
160 }
161 }